<form name="add" method="post" action="./addhairstylist.php">
	<fieldset> 
		<legend>Add a hairstylist</legend>
Hairstylist Name: <input type="text" name="hairstylist" /><br/>
Salon Name: <input type="text" name="salon" /><br/>
Telephone: <input type="text" name="telephone" /><br/>

Country: <Select NAME="country">
<?php
$sql = "SELECT CountryId, Country FROM Countries"
	." ORDER BY Country ASC";
$rs = mysql_query($sql);
echo "<option value=\"-1\"> </option>\n  ";
while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['CountryId']."\">".$row['Country']."</option>\n  ";
}
?>
</Select><br/>

Province/State: <Select NAME="region">
<?php
$sql = "SELECT RegionId, Region FROM Regions"
	//." WHERE CountryId = ".$find_country
	." ORDER BY Region ASC";
$rs = mysql_query($sql);
echo "<option value=\"-1\"> </option>\n  ";
while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['RegionId']."\">".$row['Region']."</option>\n  ";
}
?>
</Select><br/>

City <Select NAME="city">
<?php
$sql = "SELECT CityId, City FROM Cities"
	//." WHERE CountryId = ".$find_country
	//." WHERE RegionId = ".$find_region
	." ORDER BY City ASC";
$rs = mysql_query($sql);
echo "<option value=\"-1\"> </option>\n  ";
while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"".$row['CityId']."\">".$row['City']."</option>\n  ";
}
?>
</Select><br/>

<!--input type="hidden" name="searching" value="yes" /-->
<input type="submit" name="adding" value="Add" />
    </fieldset> 
</form>